-- =========================================
-- Author: Jacob Gable
-- Created: 02.00.2009
-- Notes: Creation of Blog table.
-- 
-- 
-- =========================================

IF OBJECT_ID('dbo.Blog', 'U') IS NOT NULL
  DROP TABLE dbo.Blog
GO

CREATE TABLE dbo.Blog
(
	BlogId int identity(1,1) NOT NULL, 
	Author uniqueidentifier 
			foreign key references aspnet_users(UserId) 
			NOT NULL,
	Title nvarchar(1000) NOT NULL, 
	Description nvarchar(max) NOT NULL, 
	Keywords nvarchar(1000) NOT NULL,
	ts timestamp NULL,
    CONSTRAINT PK_Blog PRIMARY KEY (BlogId)
)
GO
